home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The Business Master (3rd Edition)
/
The Business Master (3rd Edition).iso
/
files
/
comphelp
/
begin6pk
/
dbase3
< prev
next >
Wrap
Text File
|
1993-02-26
|
4KB
|
85 lines
dDase3
██████████████████████
█ BASICS OF DATABASE █
██████████████████████
A database is a collection of items that relate
to each other. For example: if you are the club
secretary, you would keep a record of the name and address
of each member.
You would also include with each member a record of their
dues paid, phone number, birthdays and other personal events.
▀ If you have a small file box, you would make a file card for
each member.
▀ Each file card is known as a RECORD.
▀ The name, address, phone number, and other information
are each called a FIELD.
▀ ROWS in a database are called Records (Left to Right).
▀ COLUMNS (Up and Down) are called Fields.
▀ Since each file card in the box contains the same kind of
of information, the file box is a Database file.
▀ The card box contains a database for club members.
FIELDS
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓Name: This is called a Field. ▓
▓Address: This is called a Field. ▓
▓City: This is called a Field. ▓
▓State: This is called a Field. ▓
▓Zip: This is called a Field. ▓
▓Phone: This is called a Field. ▓
▓Mortgages This is called a Field ▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
RECORDS (A collection of Fields make a Record)
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
▓ ▓
▓ Name Address City State Zip Phone Mortgages ▓
▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓
1 Smith, W 45 State St Lakeland FL 33780 345-6789 Ranch Estates
2 Norton,T 123 5th Ave Bartow FL 33833 555-5543 Macon Apartments
▀ The above display contains 6 Fields.
▀ The above display contains 2 Records.
▀ The information on Smith and Norton are each called a Record.
▀ The 2 Records make up the Database.
▀ The Database has been named Mortgages.
This database named "Mortgages" contains information on property
you sold to Smith and Norton.
The next sale of property, you would add another client to
your Mortgage database. Since you'll be using the same form
you will have the same information on each client.
Having the same information on each client makes possible the
real use of a database, and that is retrieving information.
You'll be able to retrieve information; like all clients that live
in particular city, or live in the same zip code area, or
purchased certain kinds of property.
Databases make it possible to find information you want
in seconds. For example, if you wanted to know what property
Smith has, simply locate his name and read across to Mortgages.
Databases are a must for businesses that want to retrieve
information quickly.
*** END OF CHAPTER ***
Press <ESC> key to return to Menu.
Select "CREATING A DATABASE", then press <Enter> key.